<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="{{ package }}.{{ class_name }}Mapper">

    <resultMap id="{{ small_class_name }}Result" type="{{ entity_package }}">
        <result column="id" property="id"/>
        {{ mapperResult }}
    </resultMap>

    <insert id="save{{ class_name }}" parameterType="{{ entity_package }}">
         insert into {{ table_name }}({{ mapperResult }}) values({{ mapperResultValue }})
    </insert>
    <select id="getAll{{ class_name }}" resultMap="{{ small_class_name }}Result"
            parameterType="{{ entity_package }}">
         select * from {{ table_name }}
    </select>
    <select id="get{{ class_name }}ByParams" resultMap="{{ small_class_name }}Result"
            parameterType="{{ entity_package }}">
         select * from {{ table_name }} where
    </select>
    <delete id="delete{{ class_name }}"
            parameterType="{{ entity_package }}">
         delete from {{ table_name }} where
    </delete>
    <update id="update{{ class_name }}"
            parameterType="{{ entity_package }}">
         update {{ table_name }} set
    </update>


</mapper>
